package com.cnsugar.common.jdbctest.bean;

import com.cnsugar.common.jdbc.annotation.Field;
import com.cnsugar.common.jdbc.annotation.Table;

import java.io.Serializable;
import java.util.Date;

/**
 * @Author Sugar
 * @Version 2018/12/17 17:26
 */
@Table("SYS_USER")
public class SysUser implements Serializable {

    @Field(value=Column.ID, isPK=true)
    private Integer id; //编号

    @Field(Column.OFFICE_ID)
    private Integer officeId; //归属部门

    @Field(Column.USERNAME)
    private String username; //登录名

    @Field(Column.PASSWORD)
    private String password; //密码

    @Field(Column.NAME)
    private String name; //姓名

    @Field(Column.EMAIL)
    private String email; //邮箱

    @Field(Column.PHONE)
    private String phone; //电话

    @Field(Column.PHOTO)
    private byte[] photo; //用户头像

    @Field(Column.CREATE_DATE)
    private Date createDate; //创建时间

    @Field(Column.UPDATE_DATE)
    private Date updateDate; //更新时间

    @Field(Column.REMARKS)
    private String remarks; //备注信息

    @Field(Column.DEL_FLAG)
    private String delFlag = "0"; //删除标记


    public void setId(Integer id) {
        this.id = id;
    }
    public Integer getId() {
        return this.id;
    }
    public void setOfficeId(Integer officeId) {
        this.officeId = officeId;
    }
    public Integer getOfficeId() {
        return this.officeId;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getUsername() {
        return this.username;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public String getPassword() {
        return this.password;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getName() {
        return this.name;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    public String getEmail() {
        return this.email;
    }
    public void setPhone(String phone) {
        this.phone = phone;
    }
    public String getPhone() {
        return this.phone;
    }
    public void setPhoto(byte[] photo) {
        this.photo = photo;
    }
    public byte[] getPhoto() {
        return this.photo;
    }
    public void setCreateDate(Date createDate) {
        this.createDate = createDate;
    }
    public Date getCreateDate() {
        return this.createDate;
    }
    public void setUpdateDate(Date updateDate) {
        this.updateDate = updateDate;
    }
    public Date getUpdateDate() {
        return this.updateDate;
    }
    public void setRemarks(String remarks) {
        this.remarks = remarks;
    }
    public String getRemarks() {
        return this.remarks;
    }
    public void setDelFlag(String delFlag) {
        this.delFlag = delFlag;
    }
    public String getDelFlag() {
        return this.delFlag;
    }

    public static class Column {
        public static final String ID = "id";
        public static final String OFFICE_ID = "office_id";
        public static final String USERNAME = "username";
        public static final String PASSWORD = "password";
        public static final String NAME = "name";
        public static final String EMAIL = "email";
        public static final String PHONE = "phone";
        public static final String PHOTO = "photo";
        public static final String CREATE_DATE = "create_date";
        public static final String UPDATE_DATE = "update_date";
        public static final String REMARKS = "remarks";
        public static final String DEL_FLAG = "del_flag";
    }
}
